Prisma ClientのFiltering
from Prisma Client
docs
API Reference
#WIP
PrismaにはLIKE句がない
たぶんmrsekut.icon
代わりにこのFileringを使う
orとかand
https://www.prisma.io/docs/concepts/components/prisma-client/crud#filter-by-multiple-field-values
code:ts
const users = await prisma.user.findMany({
where: {
OR: [
{
name: {
startsWith: 'E',
},
},
{
AND: {
profileViews: {
gt: 0,
},
role: {
equals: 'ADMIN',
},
},
},
],
},
})
https://www.prisma.io/docs/reference/api-reference/prisma-client-reference#filter-conditions-and-operators
Filter conditions and operators
equals
not
in
notIn
lt
lte
gt
gte
contains
search
mode
startsWith
endsWith
AND
OR
NOT
Relation filters
some
every
none
is
isNot